SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwtconstrucciones
AS
SELECT     dbo.u_f2_00_varios.Id AS ID, dbo.u_f2_00_varios.idCui, dbo.u_f2_00_varios.construccion, dbo.u_f2_00_varios.observaciones, 
                      dbo.u_f2_00_varios.supCubierta, dbo.u_f2_00_varios.supSemicubierta, dbo.u_f2_00_varios.superficieTotal, dbo.u_cui.cui
FROM         dbo.u_f2_00_varios INNER JOIN
                      dbo.u_fg_00_varios ON dbo.u_f2_00_varios.idCui = dbo.u_fg_00_varios.idCui INNER JOIN
                      dbo.u_cui ON dbo.u_fg_00_varios.idCui = dbo.u_cui.Id


GO
GRANT SELECT ON  [dbo].[vwtconstrucciones] TO [Cenie]
GO
